Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ItemID (FK)(PK) | A unique system assigned identifier for the retailer's SKU. | ID_ITM | IdentityUUID | char(32) | SerializedItem(AS_ITM_SRZ) |
SerialNumber (PK) | A unique code, which can be either alpha, numeric or alpha-numeric, to identify an individual ITEM. | ID_NMB_SRZ | Name | varchar(40) | |
EquipmentID (FK) | The fixed asset number assigned by the retailer for this particular piece of equipment. | ID_EQ | Identity | integer | Equipment(AS_EQ) |
TypeCode | A code to indicate the type of SERIAL ITEM, eg TV, refrigerator, PC, etc. | TY_ITM_SRZ | Code2 | char(2) | |
WarrantyCode | A code to signify the type of warranty associated with the SERIAL ITEM. This code will include the length of the warranty. | LU_WRTY_SRZ_UN | Code2 | char(2) | |
IssuedByPartyID (FK) | A unique, system assigned identity for a Party. | ID_PRTY_ISS | Identity | integer | Party(PA_PRTY) |
ItemTraceableUnitID (FK) | A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. | ID_ITM_UN_TRC | IdentityUUID | CHAR(32) | ItemTraceableUnit(AS_ITM_TRCBL_UN) |